CREATE PROCEDURE spAddOrder
(
	@CustomerID	char(5)
)
 AS
	INSERT INTO Orders (CustomerID, OrderDate)
	VALUES		(@CustomerID, GetDate())
	RETURN @@IDENTITY
